<!--

     Licensed to the Apache Software Foundation (ASF) under one
     or more contributor license agreements.  See the NOTICE file
     distributed with this work for additional information
     regarding copyright ownership.  The ASF licenses this file
     to you under the Apache License, Version 2.0 (the
     "License"); you may not use this file except in compliance
     with the License.  You may obtain a copy of the License at

       http://www.apache.org/licenses/LICENSE-2.0

     Unless required by applicable law or agreed to in writing,
     software distributed under the License is distributed on an
     "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
     KIND, either express or implied.  See the License for the
     specific language governing permissions and limitations
     under the License.

-->
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<!-- **************************************************************** -->
<!-- *  PLEASE KEEP COMPLICATED EXPRESSIONS OUT OF THESE TEMPLATES, * -->
<!-- *  i.e. only iterate & print data where possible. Thanks, Jez. * -->
<!-- **************************************************************** -->

<html>
<head>
    <!-- Generated by groovydoc (2.4.7) on Thu Dec 01 22:36:11 PST 2016 -->
    <title>EntityFacade (Moqui Framework 2.0.0)</title>
    <meta name="date" content="2016-12-01">
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
    <link href="../../../groovy.ico" type="image/x-icon" rel="shortcut icon">
    <link href="../../../groovy.ico" type="image/x-icon" rel="icon">
    <link rel="stylesheet" type="text/css" href="../../../stylesheet.css" title="Style">

<body class="center">
<script type="text/javascript"><!--
if (location.href.indexOf('is-external=true') == -1) {
    parent.document.title="EntityFacade (Moqui Framework 2.0.0)";
}
//-->
</script>
<noscript>
    <div>JavaScript is disabled on your browser.</div>
</noscript>
<!-- ========= START OF TOP NAVBAR ======= -->
<div class="topNav"><a name="navbar_top">
    <!--   -->
</a><a href="#skip-navbar_top" title="Skip navigation links"></a><a name="navbar_top_firstrow">
    <!--   -->
</a>
    <ul class="navList" title="Navigation">
        <li><a href="../../../overview-summary.html">Overview</a></li>
        <li><a href="package-summary.html">Package</a></li>
        <li class="navBarCell1Rev">Class</li>
        <li><a href="../../../deprecated-list.html">Deprecated</a></li>
        <li><a href="../../../index-all.html">Index</a></li>
        <li><a href="../../../help-doc.html">Help</a></li>
    </ul>
</div>

<div class="subNav">
    <div>
        <ul class="navList">
            <li><a href="../../../index.html?org/moqui/entity/EntityFacade" target="_top">Frames</a></li>
            <li><a href="EntityFacade.html" target="_top">No Frames</a></li>
        </ul>
    </div>
    <div>
        <ul class="subNavList">
            <li>Summary:&nbsp;</li>
            Nested&nbsp;&nbsp;&nbsp;Field&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<li><a href="#method_summary">Method</a></li>&nbsp;&nbsp;&nbsp;
        </ul>
        <ul class="subNavList">
            <li>&nbsp;|&nbsp;Detail:&nbsp;</li>
            Field&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<li><a href="#method_detail">Method</a></li>&nbsp;&nbsp;&nbsp;
        </ul>
    </div>
    <a name="skip-navbar_top">
        <!--   -->
    </a></div>
<!-- ========= END OF TOP NAVBAR ========= -->

<!-- ======== START OF CLASS DATA ======== -->
<div class="header">

    <div class="subTitle">Package: <strong>org.moqui.entity</strong></div>

    <h2 title="[Java] Interface EntityFacade" class="title">[Java] Interface EntityFacade</h2>
</div>
<div class="contentContainer">
<ul class="inheritance">

</ul>
<div class="description">
    <ul class="blockList">
        <li class="blockList">


    <p> The main interface for general database operations in Moqui. </p>

          </li>
    </ul>
</div>

<div class="summary">
    <ul class="blockList">
        <li class="blockList">
        <!-- =========== NESTED CLASS SUMMARY =========== -->
        

        <!-- =========== ENUM CONSTANT SUMMARY =========== -->
        
        <!-- =========== FIELD SUMMARY =========== -->
        

        <!-- =========== PROPERTY SUMMARY =========== -->
        

        <!-- =========== ELEMENT SUMMARY =========== -->
        

        

        
        <!-- ========== METHOD SUMMARY =========== -->
        <ul class="blockList">
            
            <li class="blockList"><a name="method_summary"><!--   --></a>
                    <h3>Methods Summary</h3>
                    <ul class="blockList">
                    <table class="overviewSummary" border="0" cellpadding="3" cellspacing="0" summary="Methods Summary table">
                        <caption><span>Methods</span><span class="tabEnd">&nbsp;</span></caption>
                        <tr>
                            <th class="colFirst" scope="col">Type</th>
                            <th class="colLast" scope="col">Name and description</th>
                        </tr>
                        
                        <tr class="altColor">
                            <td class="colFirst"><code><a href='../../../org/moqui/entity/EntityFind.html'>EntityFind</a></strong></code></td>
                            <td class="colLast"><code><strong><a href="#find(java.lang.String)">find</a></strong>(java.lang.String entityName)</code><br>Create an EntityFind object that can be used to specify additional options, and then to execute one or more
 finds (queries).</td>
                        </tr>
                        
                        <tr class="rowColor">
                            <td class="colFirst"><code><a href='../../../org/moqui/entity/EntityFind.html'>EntityFind</a></strong></code></td>
                            <td class="colLast"><code><strong><a href="#find(org.moqui.util.MNode)">find</a></strong>(org.moqui.util.MNode entityFindNode)</code><br></td>
                        </tr>
                        
                        <tr class="altColor">
                            <td class="colFirst"><code>java.util.Calendar</strong></code></td>
                            <td class="colLast"><code><strong><a href="#getCalendarForTzLc()">getCalendarForTzLc</a></strong>()</code><br></td>
                        </tr>
                        
                        <tr class="rowColor">
                            <td class="colFirst"><code><a href='../../../org/moqui/entity/EntityConditionFactory.html'>EntityConditionFactory</a></strong></code></td>
                            <td class="colLast"><code><strong><a href="#getConditionFactory()">getConditionFactory</a></strong>()</code><br>Get a EntityConditionFactory object that can be used to create and assemble conditions used for finds.</td>
                        </tr>
                        
                        <tr class="altColor">
                            <td class="colFirst"><code>java.sql.Connection</strong></code></td>
                            <td class="colLast"><code><strong><a href="#getConnection(java.lang.String)">getConnection</a></strong>(java.lang.String groupName)</code><br>Use this to get a Connection if you want to do JDBC operations directly. </td>
                        </tr>
                        
                        <tr class="rowColor">
                            <td class="colFirst"><code>java.util.ArrayList&lt;java.util.Map&gt;</strong></code></td>
                            <td class="colLast"><code><strong><a href="#getDataDocuments(java.lang.String, org.moqui.entity.EntityCondition, java.sql.Timestamp, java.sql.Timestamp)">getDataDocuments</a></strong>(java.lang.String dataDocumentId, <a href='../../../org/moqui/entity/EntityCondition.html'>EntityCondition</a> condition, java.sql.Timestamp fromUpdateStamp, java.sql.Timestamp thruUpdatedStamp)</code><br>Find and assemble data documents represented by a Map that can be easily turned into a JSON document. </td>
                        </tr>
                        
                        <tr class="altColor">
                            <td class="colFirst"><code>java.util.ArrayList&lt;java.util.Map&gt;</strong></code></td>
                            <td class="colLast"><code><strong><a href="#getDataFeedDocuments(java.lang.String, java.sql.Timestamp, java.sql.Timestamp)">getDataFeedDocuments</a></strong>(java.lang.String dataFeedId, java.sql.Timestamp fromUpdateStamp, java.sql.Timestamp thruUpdatedStamp)</code><br>Find and assemble data documents represented by a Map that can be easily turned into a JSON document. </td>
                        </tr>
                        
                        <tr class="rowColor">
                            <td class="colFirst"><code><a href='../../../org/moqui/entity/EntityDatasourceFactory.html'>EntityDatasourceFactory</a></strong></code></td>
                            <td class="colLast"><code><strong><a href="#getDatasourceFactory(java.lang.String)">getDatasourceFactory</a></strong>(java.lang.String groupName)</code><br>Get a EntityDatasourceFactory implementation for a group. </td>
                        </tr>
                        
                        <tr class="altColor">
                            <td class="colFirst"><code>java.lang.String</strong></code></td>
                            <td class="colLast"><code><strong><a href="#getEntityGroupName(java.lang.String)">getEntityGroupName</a></strong>(java.lang.String entityName)</code><br>Gets the group name for specified entityName</td>
                        </tr>
                        
                        <tr class="rowColor">
                            <td class="colFirst"><code><a href='../../../org/moqui/entity/EntityDataLoader.html'>EntityDataLoader</a></strong></code></td>
                            <td class="colLast"><code><strong><a href="#makeDataLoader()">makeDataLoader</a></strong>()</code><br>Make an object used to load XML or CSV entity data into the database or into an EntityList. </td>
                        </tr>
                        
                        <tr class="altColor">
                            <td class="colFirst"><code><a href='../../../org/moqui/entity/EntityDataWriter.html'>EntityDataWriter</a></strong></code></td>
                            <td class="colLast"><code><strong><a href="#makeDataWriter()">makeDataWriter</a></strong>()</code><br>Used to write XML entity data from the database to a writer.</td>
                        </tr>
                        
                        <tr class="rowColor">
                            <td class="colFirst"><code><a href='../../../org/moqui/entity/EntityValue.html'>EntityValue</a></strong></code></td>
                            <td class="colLast"><code><strong><a href="#makeValue(java.lang.String)">makeValue</a></strong>(java.lang.String entityName)</code><br>Creates a Entity in the form of a EntityValue without persisting it</td>
                        </tr>
                        
                        <tr class="altColor">
                            <td class="colFirst"><code><a href='../../../org/moqui/entity/EntityValue.html'>EntityValue</a></strong></code></td>
                            <td class="colLast"><code><strong><a href="#makeValue(org.w3c.dom.Element)">makeValue</a></strong>(org.w3c.dom.Element element)</code><br>Make an EntityValue and populate it with the data (attributes and sub-elements) from the given XML element.</td>
                        </tr>
                        
                        <tr class="rowColor">
                            <td class="colFirst"><code>java.lang.Object</strong></code></td>
                            <td class="colLast"><code><strong><a href="#rest(java.lang.String, List<String>, java.util.Map, boolean)">rest</a></strong>(java.lang.String operation, java.util.List&lt;java.lang.String&gt; entityPath, java.util.Map parameters, boolean masterNameInPath)</code><br>Meant for processing entity REST requests, but useful more generally as a simple way to perform entity operations.</td>
                        </tr>
                        
                        <tr class="altColor">
                            <td class="colFirst"><code>java.lang.String</strong></code></td>
                            <td class="colLast"><code><strong><a href="#sequencedIdPrimary(java.lang.String, java.lang.Long, java.lang.Long)">sequencedIdPrimary</a></strong>(java.lang.String seqName, java.lang.Long staggerMax, java.lang.Long bankSize)</code><br>Get the next guaranteed unique seq id from the sequence with the given sequence name;
 if the named sequence doesn't exist, it will be created.</td>
                        </tr>
                        
                        <tr class="rowColor">
                            <td class="colFirst"><code><a href='../../../org/moqui/entity/EntityListIterator.html'>EntityListIterator</a></strong></code></td>
                            <td class="colLast"><code><strong><a href="#sqlFind(java.lang.String, List<Object>, java.lang.String, List<String>)">sqlFind</a></strong>(java.lang.String sql, java.util.List&lt;java.lang.Object&gt; sqlParameterList, java.lang.String entityName, java.util.List&lt;java.lang.String&gt; fieldList)</code><br>Do a database query with the given SQL and return the results as an EntityList for the given entity and with
 selected columns mapped to the listed fields.</td>
                        </tr>
                        
                    </table>
                   </ul>
              </li>
            
        </ul>
        
    </li>
    </ul>
</div>

<div class="details">
    <ul class="blockList">
        <li class="blockList">
           

            

            

            

            


            
            <!-- =========== METHOD DETAIL =========== -->
            <ul class="blockList">
                <li class="blockList"><a name="method_detail">
                    <!--   -->
                </a>
                    <h3>Method Detail</h3>
                    
                        <a name="find(java.lang.String)"><!-- --></a>
                        <ul class="blockListLast">
                            <li class="blockList">
                                <h4>public&nbsp;<a href='../../../org/moqui/entity/EntityFind.html'>EntityFind</a> <strong>find</strong>(java.lang.String entityName)</h4>
                                <p> Create an EntityFind object that can be used to specify additional options, and then to execute one or more
 finds (queries).
     <DL><DT><B>Returns:</B></DT><DD>An EntityFind object.</DD></DL><DL><DT><B>Parameters:</B></DT><DD><code>entityName</code> -  The Name of the Entity as defined in the entity XML file, can be null.</DD></DL></p>
                            </li>
                        </ul>
                    
                        <a name="find(org.moqui.util.MNode)"><!-- --></a>
                        <ul class="blockListLast">
                            <li class="blockList">
                                <h4>public&nbsp;<a href='../../../org/moqui/entity/EntityFind.html'>EntityFind</a> <strong>find</strong>(org.moqui.util.MNode entityFindNode)</h4>
                                <p></p>
                            </li>
                        </ul>
                    
                        <a name="getCalendarForTzLc()"><!-- --></a>
                        <ul class="blockListLast">
                            <li class="blockList">
                                <h4>public&nbsp;java.util.Calendar <strong>getCalendarForTzLc</strong>()</h4>
                                <p></p>
                            </li>
                        </ul>
                    
                        <a name="getConditionFactory()"><!-- --></a>
                        <ul class="blockListLast">
                            <li class="blockList">
                                <h4>public&nbsp;<a href='../../../org/moqui/entity/EntityConditionFactory.html'>EntityConditionFactory</a> <strong>getConditionFactory</strong>()</h4>
                                <p> Get a EntityConditionFactory object that can be used to create and assemble conditions used for finds.
     <DL><DT><B>Returns:</B></DT><DD>The facade's active EntityConditionFactory object.</DD></DL></p>
                            </li>
                        </ul>
                    
                        <a name="getConnection(java.lang.String)"><!-- --></a>
                        <ul class="blockListLast">
                            <li class="blockList">
                                <h4>public&nbsp;java.sql.Connection <strong>getConnection</strong>(java.lang.String groupName)</h4>
                                <p> Use this to get a Connection if you want to do JDBC operations directly. This Connection will be enlisted in
 the active Transaction.<DL><DT><B>throws:</B></DT><DD>EntityException</DD></DL>
     <DL><DT><B>Returns:</B></DT><DD>JDBC Connection object for the associated database</DD></DL><DL><DT><B>Parameters:</B></DT><DD><code>groupName</code> -  The name of entity group to get a connection for.
     Corresponds to the entity.@group attribute and the moqui-conf datasource.@group-name attribute.</DD></DL></p>
                            </li>
                        </ul>
                    
                        <a name="getDataDocuments(java.lang.String, org.moqui.entity.EntityCondition, java.sql.Timestamp, java.sql.Timestamp)"><!-- --></a>
                        <ul class="blockListLast">
                            <li class="blockList">
                                <h4>public&nbsp;java.util.ArrayList&lt;java.util.Map&gt; <strong>getDataDocuments</strong>(java.lang.String dataDocumentId, <a href='../../../org/moqui/entity/EntityCondition.html'>EntityCondition</a> condition, java.sql.Timestamp fromUpdateStamp, java.sql.Timestamp thruUpdatedStamp)</h4>
                                <p> Find and assemble data documents represented by a Map that can be easily turned into a JSON document. This is
 used for searching by the Data Search feature and for data feeds to other systems with the Data Feed feature.
     <DL><DT><B>Returns:</B></DT><DD>List of Maps with these entries:
      - _index = DataDocument.indexName
      - _type = dataDocumentId
      - _id = pk field values from primary entity, underscore separated
      - _timestamp = timestamp when the document was created
      - Map for primary entity (with primaryEntityName as key)
      - nested List of Maps for each related entity from DataDocumentField records with aliased fields
          (with relationship name as key)</DD></DL><DL><DT><B>Parameters:</B></DT><DD><code>dataDocumentId</code> -  Used to look up the DataDocument and related records (DataDocument* entities).</DD><DD><code>condition</code> -  An optional condition to AND with from/thru updated timestamps and any DataDocumentCondition
                  records associated with the DataDocument.</DD><DD><code>fromUpdateStamp</code> -  The lastUpdatedStamp on at least one entity selected must be after (&gt;=) this Timestamp.</DD><DD><code>thruUpdatedStamp</code> -  The lastUpdatedStamp on at least one entity selected must be before (&lt;) this Timestamp.</DD></DL></p>
                            </li>
                        </ul>
                    
                        <a name="getDataFeedDocuments(java.lang.String, java.sql.Timestamp, java.sql.Timestamp)"><!-- --></a>
                        <ul class="blockListLast">
                            <li class="blockList">
                                <h4>public&nbsp;java.util.ArrayList&lt;java.util.Map&gt; <strong>getDataFeedDocuments</strong>(java.lang.String dataFeedId, java.sql.Timestamp fromUpdateStamp, java.sql.Timestamp thruUpdatedStamp)</h4>
                                <p> Find and assemble data documents represented by a Map that can be easily turned into a JSON document. This is
 similar to the getDataDocuments() method except that the dataDocumentId(s) are looked up using the dataFeedId.
     <DL><DT><B>Returns:</B></DT><DD>List of Maps with these entries:</DD></DL><DL><DT><B>Parameters:</B></DT><DD><code>dataFeedId</code> -  Used to look up the DataFeed records to find the associated DataDocument records.</DD><DD><code>fromUpdateStamp</code> -  The lastUpdatedStamp on at least one entity selected must be after (&gt;=) this Timestamp.</DD><DD><code>thruUpdatedStamp</code> -  The lastUpdatedStamp on at least one entity selected must be before (&lt;) this Timestamp.</DD></DL></p>
                            </li>
                        </ul>
                    
                        <a name="getDatasourceFactory(java.lang.String)"><!-- --></a>
                        <ul class="blockListLast">
                            <li class="blockList">
                                <h4>public&nbsp;<a href='../../../org/moqui/entity/EntityDatasourceFactory.html'>EntityDatasourceFactory</a> <strong>getDatasourceFactory</strong>(java.lang.String groupName)</h4>
                                <p> Get a EntityDatasourceFactory implementation for a group. This is most useful for non-SQL databases to get
 access to underlying details. </p>
                            </li>
                        </ul>
                    
                        <a name="getEntityGroupName(java.lang.String)"><!-- --></a>
                        <ul class="blockListLast">
                            <li class="blockList">
                                <h4>public&nbsp;java.lang.String <strong>getEntityGroupName</strong>(java.lang.String entityName)</h4>
                                <p> Gets the group name for specified entityName
     <DL><DT><B>Returns:</B></DT><DD>String with the group name that corresponds to the entityName</DD></DL><DL><DT><B>Parameters:</B></DT><DD><code>entityName</code> -  The name of the entity to get the group name</DD></DL></p>
                            </li>
                        </ul>
                    
                        <a name="makeDataLoader()"><!-- --></a>
                        <ul class="blockListLast">
                            <li class="blockList">
                                <h4>public&nbsp;<a href='../../../org/moqui/entity/EntityDataLoader.html'>EntityDataLoader</a> <strong>makeDataLoader</strong>()</h4>
                                <p> Make an object used to load XML or CSV entity data into the database or into an EntityList. The files come from
 a specific location, text already read from somewhere, or by searching all component data directories
 and the entity-facade.load-data elements for entity data files that match a type in the Set of types
 specified.

 An XML document should have a root element like <code>&lt;entity-facade-xml type=&quot;seed&quot;&gt;</code>. The
 type attribute will be used to determine if the file should be loaded by whether or not it matches the values
 specified for data types on the loader.
     <DL><DT><B>Returns:</B></DT><DD>EntityDataLoader instance</DD></DL></p>
                            </li>
                        </ul>
                    
                        <a name="makeDataWriter()"><!-- --></a>
                        <ul class="blockListLast">
                            <li class="blockList">
                                <h4>public&nbsp;<a href='../../../org/moqui/entity/EntityDataWriter.html'>EntityDataWriter</a> <strong>makeDataWriter</strong>()</h4>
                                <p> Used to write XML entity data from the database to a writer.

 The document will have a root element like <code>&lt;entity-facade-xml&gt;</code>.
     <DL><DT><B>Returns:</B></DT><DD>EntityDataWriter instance</DD></DL></p>
                            </li>
                        </ul>
                    
                        <a name="makeValue(java.lang.String)"><!-- --></a>
                        <ul class="blockListLast">
                            <li class="blockList">
                                <h4>public&nbsp;<a href='../../../org/moqui/entity/EntityValue.html'>EntityValue</a> <strong>makeValue</strong>(java.lang.String entityName)</h4>
                                <p> Creates a Entity in the form of a EntityValue without persisting it 
     <DL><DT><B>Returns:</B></DT><DD>EntityValue for the named entity.</DD></DL><DL><DT><B>Parameters:</B></DT><DD><code>entityName</code> -  The name of the entity to make a value object for.</DD></DL></p>
                            </li>
                        </ul>
                    
                        <a name="makeValue(org.w3c.dom.Element)"><!-- --></a>
                        <ul class="blockListLast">
                            <li class="blockList">
                                <h4>public&nbsp;<a href='../../../org/moqui/entity/EntityValue.html'>EntityValue</a> <strong>makeValue</strong>(org.w3c.dom.Element element)</h4>
                                <p> Make an EntityValue and populate it with the data (attributes and sub-elements) from the given XML element.
     <DL><DT><B>Returns:</B></DT><DD>EntityValue object populated with data from the element.</DD></DL><DL><DT><B>Parameters:</B></DT><DD><code>element</code> -  A XML DOM element representing a single value/record for an entity.</DD></DL></p>
                            </li>
                        </ul>
                    
                        <a name="rest(java.lang.String, List<String>, java.util.Map, boolean)"><!-- --></a>
                        <ul class="blockListLast">
                            <li class="blockList">
                                <h4>public&nbsp;java.lang.Object <strong>rest</strong>(java.lang.String operation, java.util.List&lt;java.lang.String&gt; entityPath, java.util.Map parameters, boolean masterNameInPath)</h4>
                                <p> Meant for processing entity REST requests, but useful more generally as a simple way to perform entity operations.
     <DL><DT><B>Parameters:</B></DT><DD><code>operation</code> -  Can be get/find, post/create, put/store, patch/update, or delete/delete.</DD><DD><code>entityPath</code> -  First element should be an entity name or short-alias, followed by (optionally depending on
                   operation) the PK fields for the entity in the order they appear in the entity definition
                   followed optionally by (one or more) relationship name or short-alias and then PK values for
                   the related entity, not including any PK fields defined in the relationship.</DD><DD><code>parameters</code> -  A Map of extra parameters, used depending on the operation. For find operations these can be
                   any parameters handled by the EntityFind.searchFormInputs() method. For create, update, store,
                   and delete operations these parameters are for non-PK fields and as an alternative to the
                   entity path for PK field values. For find operations also supports a "dependents" parameter
                   that if true will get dependent values of the record referenced in the entity path.</DD><DD><code>masterNameInPath</code> -  If true the second entityPath entry must be the name of a master entity definition</DD></DL></p>
                            </li>
                        </ul>
                    
                        <a name="sequencedIdPrimary(java.lang.String, java.lang.Long, java.lang.Long)"><!-- --></a>
                        <ul class="blockListLast">
                            <li class="blockList">
                                <h4>public&nbsp;java.lang.String <strong>sequencedIdPrimary</strong>(java.lang.String seqName, java.lang.Long staggerMax, java.lang.Long bankSize)</h4>
                                <p> Get the next guaranteed unique seq id from the sequence with the given sequence name;
 if the named sequence doesn't exist, it will be created.
     <DL><DT><B>Returns:</B></DT><DD>Long with the next seq id for the given sequence name</DD></DL><DL><DT><B>Parameters:</B></DT><DD><code>seqName</code> -  The name of the sequence to get the next seq id from</DD><DD><code>staggerMax</code> -  The maximum amount to stagger the sequenced ID, if 1 the sequence will be incremented by 1,
     otherwise the current sequence ID will be incremented by a value between 1 and staggerMax</DD><DD><code>bankSize</code> -  The size of the "bank" of values to get from the database (defaults to 1)</DD></DL></p>
                            </li>
                        </ul>
                    
                        <a name="sqlFind(java.lang.String, List<Object>, java.lang.String, List<String>)"><!-- --></a>
                        <ul class="blockListLast">
                            <li class="blockList">
                                <h4>public&nbsp;<a href='../../../org/moqui/entity/EntityListIterator.html'>EntityListIterator</a> <strong>sqlFind</strong>(java.lang.String sql, java.util.List&lt;java.lang.Object&gt; sqlParameterList, java.lang.String entityName, java.util.List&lt;java.lang.String&gt; fieldList)</h4>
                                <p> Do a database query with the given SQL and return the results as an EntityList for the given entity and with
 selected columns mapped to the listed fields.
     <DL><DT><B>Returns:</B></DT><DD>EntityListIterator with results of query.</DD></DL><DL><DT><B>Parameters:</B></DT><DD><code>sql</code> -  The actual SQL to run.</DD><DD><code>sqlParameterList</code> -  Parameter values that correspond with any question marks (?) in the SQL.</DD><DD><code>entityName</code> -  Name of the entity to map the results to.</DD><DD><code>fieldList</code> -  List of entity field names in order that they match columns selected in the query.</DD></DL></p>
                            </li>
                        </ul>
                    
                </li>
            </ul>
            
        </li>
    </ul>
</div>

<!-- ========= END OF CLASS DATA ========= -->
<!-- ======= START OF BOTTOM NAVBAR ====== -->
<div class="bottomNav"><a name="navbar_bottom">
    <!--   -->
</a><a href="#skip-navbar_bottom" title="Skip navigation links"></a><a name="navbar_bottom_firstrow">
    <!--   -->
</a>
    <ul class="navList" title="Navigation">
        <li><a href="../../../overview-summary.html">Overview</a></li>
        <li><a href="package-summary.html">Package</a></li>
        <li class="navBarCell1Rev">Class</li>
        <li><a href="../../../deprecated-list.html">Deprecated</a></li>
        <li><a href="../../../index-all.html">Index</a></li>
        <li><a href="../../../help-doc.html">Help</a></li>
    </ul>
</div>

<div class="subNav">
    <div>
        <ul class="navList">
            <li><a href="../../../index.html?org/moqui/entity/EntityFacade" target="_top">Frames</a></li>
            <li><a href="EntityFacade.html" target="_top">No Frames</a></li>
        </ul>
    </div>
    <div>
        <ul class="subNavList">
            <li>Summary:&nbsp;</li>
            Nested&nbsp;&nbsp;&nbsp;Field&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<li><a href="#method_summary">Method</a></li>&nbsp;&nbsp;&nbsp;
        </ul>
        <ul class="subNavList">
            <li>&nbsp;|&nbsp;Detail:&nbsp;</li>
            Field&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<li><a href="#method_detail">Method</a></li>&nbsp;&nbsp;&nbsp;
        </ul>
    </div>
    <p>Groovy Documentation</p>
    <a name="skip-navbar_bottom">
        <!--   -->
    </a>
    </div>
</div>
<!-- ======== END OF BOTTOM NAVBAR ======= -->
</body>
</html>
